Get Row Count

Command Prototype

iRet = Excel.GetRowsCount(objExcelWorkBook,sheet)

Command Description

Get the number of rows used in the sheet

Parameter Description

Required Parameter

objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel))

sheet--If a string is used, it refers to the name of the specified sheet; if a number is used, it refers to the index of the specified sheet (starting from 0)

return

iRet--The variable used to save the output of the function call